package com.wx.plugin.repository;


import com.yangzcp.userpojo.Members_account_log;
import com.yangzcp.userpojo.Members_account_log_on;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

public interface Members_account_log_onRepository extends JpaRepository<Members_account_log_on, Integer>{

    @Query("select count(*) as num, sum(amount) as amount_all from Members_account_log_on where ref_member.id=?1 and log_level=?2")
    Map<String, Object> showLogOn(Integer id, Integer log_level);

}
